package com.zzyl.serve.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zzyl.serve.domain.NursingService;
import com.zzyl.serve.vo.NursingProjectVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 护理项目Mapper接口
 * 
 * @author ityu
 * @date 2025-10-11
 */
public interface NursingServiceMapper extends BaseMapper<NursingService>
{
    /**
     * 查询护理项目
     * 
     * @param id 护理项目主键
     * @return 护理项目
     */
    public NursingService selectNursingServiceById(Long id);

    /**
     * 查询护理项目列表
     * 
     * @param nursingService 护理项目
     * @return 护理项目集合
     */
    public List<NursingService> selectNursingServiceList(NursingService nursingService);

    /**
     * 新增护理项目
     * 
     * @param nursingService 护理项目
     * @return 结果
     */
    public int insertNursingService(NursingService nursingService);

    /**
     * 修改护理项目
     * 
     * @param nursingService 护理项目
     * @return 结果
     */
    public int updateNursingService(NursingService nursingService);

    /**
     * 删除护理项目
     * 
     * @param id 护理项目主键
     * @return 结果
     */
    public int deleteNursingServiceById(Long id);

    /**
     * 批量删除护理项目
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteNursingServiceByIds(Long[] ids);

    @Select("select id value,name label from nursing_project where status = 1")
    List<NursingProjectVo> getAll();
}
